UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pREEo9m2ddla3m+28yPOIIcA/8IaMNSgZWgQMxGiKDM='
WHERE
key_id = '24968f5a88c0018def9d334ed1c75efb168753c077a466d2817b58cfe849bec6'
AND (
token = 'pREEo9m2ddla3m+28yPOIIcA/8IaMNSgZWgQMxGiKDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)