UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'USjUuyjB2DWBfX4LavIcU40Vlkj8QnyeYsZvlca2+F4='
WHERE
key_id = '77cc0a675ea083889ab5ea62e37a8dd1ddad2745aebe48ecd2d24c7ef2a65ca1'
AND (
token = 'USjUuyjB2DWBfX4LavIcU40Vlkj8QnyeYsZvlca2+F4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)