UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xid6t70dqth1/oHcOPC8faoKiv3rcAfOOdDA+GZRbwk='
WHERE
key_id = '8ccfe14e58930ed042c9b4c659310f1fca84c9e69a7062f4ac8ad65290b112e2'
AND (
token = 'xid6t70dqth1/oHcOPC8faoKiv3rcAfOOdDA+GZRbwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)