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