UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OaLMhF7sVHLw57l7rSQtmBpycf8Ji9M88+rHbTLzOYw='
WHERE
key_id = '49dbbf9d0df7a93474ffe1b23816819223966c50fe9efccda8fea77402e7201e'
AND (
token = 'OaLMhF7sVHLw57l7rSQtmBpycf8Ji9M88+rHbTLzOYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)