UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yHbzm3GNNLRzrvtf5wheMdPkp4TgX1GEopG4nUDu/b0='
WHERE
key_id = 'c45d154a2860c0ad7c6e91d4b75690afff40387de49ee1df50efe8efbd9b821a'
AND (
token = 'yHbzm3GNNLRzrvtf5wheMdPkp4TgX1GEopG4nUDu/b0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)