UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jMj8k0eqNRZc3RRarN001/2XnS4p4q/m6OBXjwivph8='
WHERE
key_id = '0ecd870719510891061669997cf346e2f0b8679feb5f8e1d5be8327a1cffde03'
AND (
token = 'jMj8k0eqNRZc3RRarN001/2XnS4p4q/m6OBXjwivph8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)