UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zP+faB31/hwuAgfV8mzn/JxhJypubAW7fv8M4D8loL0='
WHERE
key_id = '4dc32b91d20f87cd431debf4bd2787ce6f2378e1de8d8d9047e68bd8083cc218'
AND (
token = 'zP+faB31/hwuAgfV8mzn/JxhJypubAW7fv8M4D8loL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)