UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tnP4FqYjgaw8uplxzlvGychMKEUFbv0ZrTBHk5UL1jQ='
WHERE
key_id = '00b93de14366f7b25d36f3d0e77a4bdb610c7d8fedcce8e8747ebcfe1467517a'
AND (
token = 'tnP4FqYjgaw8uplxzlvGychMKEUFbv0ZrTBHk5UL1jQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)