UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WBMW4wzeCouleUKbVFt6+x4O1SQY4qLu1KeC7w8A12c='
WHERE
key_id = 'c12259fb9a3785aa7f963c02bbc20797b646ebe57682c8f9640e003f79c91fa7'
AND (
token = 'WBMW4wzeCouleUKbVFt6+x4O1SQY4qLu1KeC7w8A12c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)