UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BmehjNlsSw3oplF8P1ZaiRJFF47o1lIZPKBAqcuQ18k='
WHERE
key_id = '501ba84fed70eb6affea88156bae9f9729193ff0fbf1badde08673b3d9c5b323'
AND (
token = 'BmehjNlsSw3oplF8P1ZaiRJFF47o1lIZPKBAqcuQ18k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)