UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Dx4/d4S7uUzP0wZ3qAcUcn91XzzY44aTKT2M0X6J+w='
WHERE
key_id = '1aaa8d87d0bb1b14c22075e44d08355d53d2b3b009588f4e8b568a0b6c94c4ab'
AND (
token = '0Dx4/d4S7uUzP0wZ3qAcUcn91XzzY44aTKT2M0X6J+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)