UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hcWP1vSDkFNT2Uj6lOamKOAxNaKQ59WiyG2VM+4ztu8='
WHERE
key_id = 'ecd15aa716264526459b0545d54e6eb154cb010a29c87ec49177745177bb115a'
AND (
token = 'hcWP1vSDkFNT2Uj6lOamKOAxNaKQ59WiyG2VM+4ztu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)