UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cnb9fvgdHci4nUfTMScNMZZsb5Baf3Z28PbVSlnM77I='
WHERE
key_id = 'be2e4a477ba09d8685d28255b99a1f5ba580fab804bc5423b7dee7dbc84a2917'
AND (
token = 'Cnb9fvgdHci4nUfTMScNMZZsb5Baf3Z28PbVSlnM77I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)