UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cSgcMh1cNRcH52UPGSxmk+V6WJUsBDhiini5IWFJks4='
WHERE
key_id = 'dcabd59ea77f5dc7b0e0d8bbf23c32f37e664742515aae4075f4dbf9ca340c3c'
AND (
token = 'cSgcMh1cNRcH52UPGSxmk+V6WJUsBDhiini5IWFJks4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)