UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S12hnZv4Lrm6CkeoTcs9l9QjmMontca1jMzGObyxOwA='
WHERE
key_id = '4d2bbbb728fef9ca418858039394c66d6675822ca38b3747625e38ac2237ff66'
AND (
token = 'S12hnZv4Lrm6CkeoTcs9l9QjmMontca1jMzGObyxOwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)