UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W1ZfoD4uTAXgEJncK5zqb05Tp4nqw5iLS9s0GFIASus='
WHERE
key_id = '04e5b7748d5090847841d193a3c98d8973adab36e6e7ed2ce64b586ee1829048'
AND (
token = 'W1ZfoD4uTAXgEJncK5zqb05Tp4nqw5iLS9s0GFIASus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)