UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PNnTnwm0t+8jIDHHeK/kWZD6tli7x/Z2Mz0plUaJ/a0='
WHERE
key_id = '5d1e7f88fca56e9548b8e7beea8b1ff6abdddf597de5ba9f7039b85b33564e67'
AND (
token = 'PNnTnwm0t+8jIDHHeK/kWZD6tli7x/Z2Mz0plUaJ/a0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)