UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CEHUDdEuNETjs14jX/24BsAAOhU8u/R1m0SVG4RRjfU='
WHERE
key_id = '27c5d09fa2a58f835e5c87483f1dd47d471c6a43f8dc98d09899595995cd2ed0'
AND (
token = 'CEHUDdEuNETjs14jX/24BsAAOhU8u/R1m0SVG4RRjfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)