UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KmjMZD9bVq0zjn4D/Ymk+5pCjEGPnUezkHyecCywND8='
WHERE
key_id = 'ae6c4821391a87ad9fb292b0cbd87bbe702d598c39fba176abd7c03f5c1089f0'
AND (
token = 'KmjMZD9bVq0zjn4D/Ymk+5pCjEGPnUezkHyecCywND8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)