UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QhQPn/XxV4IyPsqx/8lUzQMjDAbVAcZb706QhguzUrM='
WHERE
key_id = '46edfdf7e6ab24317b8c51462cfecff24186cc46a43c61351f9f36ba340136fa'
AND (
token = 'QhQPn/XxV4IyPsqx/8lUzQMjDAbVAcZb706QhguzUrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)