UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TZ9fznDvhEADOE36E/e1bsUIBbUTJZbhZzjQDXFA5Tw='
WHERE
key_id = '8b7a90398e3d56cf272e06aeb531898b8dda68d59b52a909243779394d24acf4'
AND (
token = 'TZ9fznDvhEADOE36E/e1bsUIBbUTJZbhZzjQDXFA5Tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)