UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NHVYKB0XwQ/zNp3KHLr+T1hves80dfdgqwbYEy/CuhE='
WHERE
key_id = '556c80672c1a67a3c74508310c35793e8a403049d2c4b2f9334a857a48b5981b'
AND (
token = 'NHVYKB0XwQ/zNp3KHLr+T1hves80dfdgqwbYEy/CuhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)