UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JohO0Boz68fOihALtBt5Ylnww7EXD8gO44p+tlM9kvU='
WHERE
key_id = 'a587e95cb1eeb55fffeaf25a12eb7207ddbb283724a3b58288fff88af73f5ebe'
AND (
token = 'JohO0Boz68fOihALtBt5Ylnww7EXD8gO44p+tlM9kvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)