UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W3rfa62yBvdVJaXicLP1Y4emHtiYoGAQHW9f9trU9k4='
WHERE
key_id = 'aed0072e62187d669aa2ead39a2cd76f9a095bff933a42b46155eabcf6aeb54e'
AND (
token = 'W3rfa62yBvdVJaXicLP1Y4emHtiYoGAQHW9f9trU9k4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)