UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r6OHtjZxPnOo9npBKSiSXwEk2a8z5meW7FcQLuZ3TE4='
WHERE
key_id = '22c0d34c736fab826a8c03c0b0402df3a7c75ece791e8fa657708c4d8dda5421'
AND (
token = 'r6OHtjZxPnOo9npBKSiSXwEk2a8z5meW7FcQLuZ3TE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)