UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/W9kWGNPyc9HOipXtVeLfy76lxHNGjONl1QU3fxMXI8='
WHERE
key_id = 'd5af30267108ba0e0ca3c220a52ca15bf4387a6f1f5ad17d5bc0828639ce4a56'
AND (
token = '/W9kWGNPyc9HOipXtVeLfy76lxHNGjONl1QU3fxMXI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)