UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'COSnfOqnDYI/NsS8f8rVjfg35IwWQZr606oPm4yuNlM='
WHERE
key_id = '1e723f777b073e96302d68a964c1261653aec53cf8481e352659f8d744c7cd40'
AND (
token = 'COSnfOqnDYI/NsS8f8rVjfg35IwWQZr606oPm4yuNlM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)