UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8UFdACaqKiM4ZNO0FPduergdx2T/ydeOoPV5KLKA8uM='
WHERE
key_id = '40653fd0dcbd9aac4344b6560b96cca3cfd3b259eff8f8a24b007927d3b3174c'
AND (
token = '8UFdACaqKiM4ZNO0FPduergdx2T/ydeOoPV5KLKA8uM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)