UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6pEMO1Wrbfk4cJbIrzA5r2B10n+yf3B35oemVZm5kBs='
WHERE
key_id = '45653347d89edd165e06d76fd3b5bcfcdc15a5a88f089a5f5274581281fe924f'
AND (
token = '6pEMO1Wrbfk4cJbIrzA5r2B10n+yf3B35oemVZm5kBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)